package com.yeung.mapper.annotation;

import com.yeung.bean.Department;
import org.apache.ibatis.annotations.Select;

public interface DepartmentMapperAnnotation {
    @Select("select * from department where id=#{id}")
    Department getDeptById(Integer id);

  /*  @Select("select d.id             did,\n" +
            "       d.departmentName deptName,\n" +
            "       e.id             id,\n" +
            "       e.lastName       lastName,\n" +
            "       e.email          email,\n" +
            "       e.gender         gender\n" +
            "from department d\n" +
            "         left join tbl_employee e\n" +
            "                   on d.id = e.department\n" +
            "where d.id = ${id}")
    @ResultMap("Dept")
    Department getDeptByIdPlus(Integer id);*/

}
